package com.woniuxy.factory.mapper;

import com.woniuxy.factory.entity.PurchaseItem;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author 邹佳骏
 * @date 2020-08-17 20:40
 */
public interface PurchaseItemMapper {

    /*根据采购单号查询总条数*/
    int getCount(String purId);

    /*根据采购单号查询所有采购项并分页*/
    List<PurchaseItem> selectByPurid(@Param("purId") String purId, @Param("home") int home, @Param("limit") int limit);

    /*根据采购项序号删除当前列*/
    void deleteByPuiId(String puiID);

    /*根据指定的物料编号插入对应采购申请的采购项*/
    void insertItemByRequestNumber(@Param("purId") int purId,
                                   @Param("matId") String matId,
                                   @Param("purchaseamount") int purchaseamount);
}